UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '/RZNQiep3e09nG/gfRDXorXQfv0WvP2ra1Vdt0TAeQs=' 
WHERE 
  key_id = '4aeed8524f3b15c7f0ec1e18a3de0a5e58fa83a5b28202a3185c69c077a5b3dc' 
  AND (
    token = '/RZNQiep3e09nG/gfRDXorXQfv0WvP2ra1Vdt0TAeQs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024