UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'juaXQ3d890oxBfBBmBSvWsOaGMJ+a0mUdyVFmgKut3M=' 
WHERE 
  key_id = 'd78dc6bb54ae27cbac33cacad0ec854a9e81259b661da9466e182c3f4d251ee5' 
  AND (
    token = 'juaXQ3d890oxBfBBmBSvWsOaGMJ+a0mUdyVFmgKut3M=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022