UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '1za1ivZdtFvxtN72K7toLYaf8R7Q2dM4AEkE2eJ6xTU=' 
WHERE 
  key_id = 'b0f37ae3f45f931a7fe1a3e0bbedc7b8038ac2e5e7842eb2140f45fdf6c4900f' 
  AND (
    token = '1za1ivZdtFvxtN72K7toLYaf8R7Q2dM4AEkE2eJ6xTU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00041