UPDATE 
  vi_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'NMjXALiT9Wsz0VI9TOs2yXDbGn9TEx1uTrnNhaC/PQQ=' 
WHERE 
  key_id = '8793bff398e9e8cb9dd2943e852f79b25f158c5c345bae9947488ede7be58cc2' 
  AND (
    token = 'NMjXALiT9Wsz0VI9TOs2yXDbGn9TEx1uTrnNhaC/PQQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )