UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'V7k7t9LzbHWia76ZgEVc5Lmv+RNGceugUpp86oJ1AFk=' 
WHERE 
  key_id = '8eb274acf32fc0f079c0af42daafec5b831ed68c8110ade8dd2d0b2f16e330cf' 
  AND (
    token = 'V7k7t9LzbHWia76ZgEVc5Lmv+RNGceugUpp86oJ1AFk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021