UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'FPETkiidQMz1WWiLOB1xEt7XKpUqbzAHlVyI5Kh8BYE=' 
WHERE 
  key_id = '8d684d7415608d0424b3f782a1596cae1027b5c77399b18048ccd0e2b9c39fda' 
  AND (
    token = 'FPETkiidQMz1WWiLOB1xEt7XKpUqbzAHlVyI5Kh8BYE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00044