UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'sfuCLnC5b58K8jW6ocM76LZimvAEcKPtGmTwgqHKmT0=' 
WHERE 
  key_id = 'c4a6eb5e3d601eebff74a784f29f2eb0d4d8fd8d536b7a7b8198b365530a216d' 
  AND (
    token = 'sfuCLnC5b58K8jW6ocM76LZimvAEcKPtGmTwgqHKmT0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00041