Updating to Snow Leopard through a USB optical drive
Yes, this should work perfectly well. Almost all USB optical drives use standard drivers, so just about any one should work just fine with your MacBook Pro.