SECOND AMENDED AND RESTATED CONSOLIDATED GUARANTY AGREEMENT