UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Wok7f6Fo9Lwjz1UWI6GUpBBKf3Dpr54G/TIO6ydYvEQ=' 
WHERE 
  key_id = '3a4d1e9b6e8867c530af7bb49c35311537ac8299d0d1739adcaa520811c2f6f9' 
  AND (
    token = 'Wok7f6Fo9Lwjz1UWI6GUpBBKf3Dpr54G/TIO6ydYvEQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00036