UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'H/QDX2KgoOaK4qCF4ciokh/7j584xf0g4i4F6ShNI+U=' 
WHERE 
  key_id = '9d32415f0fcf266ef2b5a8c23e16fc97450895d50f5b69b51114baf0ef2a691b' 
  AND (
    token = 'H/QDX2KgoOaK4qCF4ciokh/7j584xf0g4i4F6ShNI+U=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033