UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ZC9R/j3a7O1BgzzMee+x084LOdJIeQOhii8LXC6o23c=' 
WHERE 
  key_id = '7afa6d71ea3d71275618ed59c43077e473b4b208b55b84936ed84de934f0f373' 
  AND (
    token = 'ZC9R/j3a7O1BgzzMee+x084LOdJIeQOhii8LXC6o23c=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00015