UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Mz2q+7YCq/ohC3gkTJ4f+dB3SmdtDUJk8yvsFBVDX4k=' 
WHERE 
  key_id = '74ef51393768ee1e83a58ecb7afc064aafb80e617e87a4d20c8755ff0e1ad2e6' 
  AND (
    token = 'Mz2q+7YCq/ohC3gkTJ4f+dB3SmdtDUJk8yvsFBVDX4k=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00038