Rotating passwords

Yes, that should work assuming your app never has to reconnect (e.g. due to network issues) once it has started.