UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'vEFKozTte4Rd4EjUZKYYr5d62rwhmnGBwWStnqjnYS4=' 
WHERE 
  key_id = '97ff98cf63f3d660f1d32cf3c44aa9d32c46884b142d81317e2a2e7bab62e6e7' 
  AND (
    token = 'vEFKozTte4Rd4EjUZKYYr5d62rwhmnGBwWStnqjnYS4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029