Missouri governor resigns amid affair scandal