UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'vzQ6aU/NY03+quDKfuZCxJFrA6omx0IpPXQ/0JnEe6M=' 
WHERE 
  key_id = 'c71451ef47c8fc9369fece207ecfcf12c0e82edd6c87862e3a6528af2b547951' 
  AND (
    token = 'vzQ6aU/NY03+quDKfuZCxJFrA6omx0IpPXQ/0JnEe6M=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022