UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'DLEec06uThNOV2kUzux2CoX0rEVgq3gm/1eAUEvEbW8=' 
WHERE 
  key_id = '749bd49b77a8afc70f72ca0c6da5b26cb40f7f90d7e6d05a68c902bea469b1d3' 
  AND (
    token = 'DLEec06uThNOV2kUzux2CoX0rEVgq3gm/1eAUEvEbW8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00039