UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ClgV4S2lNj1kV4+/8y8bXv9MS3qqtHJ8eyk1U5E3SoI=' 
WHERE 
  key_id = '53d88a46a169790385b24fe5014ba0dee2eb2a87d820cbb9238ef3c6cf8983d7' 
  AND (
    token = 'ClgV4S2lNj1kV4+/8y8bXv9MS3qqtHJ8eyk1U5E3SoI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00054