UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'hPuLlSCip5mVb+QiXPVFTjct4zx5soUXQ7jP3FxeVGY=' 
WHERE 
  key_id = '6c83c0891bb79f00a9f25460c5ec93515c8adb24a0f49e3cc5271a6fdd570391' 
  AND (
    token = 'hPuLlSCip5mVb+QiXPVFTjct4zx5soUXQ7jP3FxeVGY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00045