UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'sWglK5RESP4Rt0+Eo1dHK+5o68uhsJhgKs6z2/qhahk=' 
WHERE 
  key_id = 'e8c6c164ff4d6779589532615a94370a4519f9788226627efadcea824c68003e' 
  AND (
    token = 'sWglK5RESP4Rt0+Eo1dHK+5o68uhsJhgKs6z2/qhahk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00048