UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'GWXj9hGej/+fStrrfpHaHVuqnucbmTvWaEZiJTSW8FM=' 
WHERE 
  key_id = '6d28f2ef7f243889d305ed9df555177516f9b934220bf6690705304283a81d02' 
  AND (
    token = 'GWXj9hGej/+fStrrfpHaHVuqnucbmTvWaEZiJTSW8FM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028