UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '+N4Fmsw5tnCebdOxjkWpXSc0Q5kfmjWGcfe5TNTtAhQ=' 
WHERE 
  key_id = '277e00a51a5abb9748ed2898ef4d473e119fd7e5c6aef8ebadf8ba38f390645a' 
  AND (
    token = '+N4Fmsw5tnCebdOxjkWpXSc0Q5kfmjWGcfe5TNTtAhQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00048