UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '42mW9Sc4pwnzeL0xPNBPqf8xuO+j2VraieWVjMIieQo=' 
WHERE 
  key_id = '526bd32755f503415021de61e84e648d004226c796aa8a6b648b04ed00a97371' 
  AND (
    token = '42mW9Sc4pwnzeL0xPNBPqf8xuO+j2VraieWVjMIieQo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021