UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '9zTkpRclqdXXtCiCKZHgehvHY1Xn41fJCGBG/BMNYyM=' 
WHERE 
  key_id = '428a3df7c3f2768c21a1078d29ef72a2793a263b37533cb0f6e2f51699172666' 
  AND (
    token = '9zTkpRclqdXXtCiCKZHgehvHY1Xn41fJCGBG/BMNYyM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00055