SECOND AMENDED AND RESTATED ADVISORY AGREEMENT AMONG MOODY NATIONAL REIT II, INC., MOODY NATIONAL OPERATING PARTNERSHIP II, LP, AND MOODY NATIONAL ADVISOR II, LLC SECOND AMENDED AND RESTATED ADVISORY AGREEMENT