SECOND AMENDED AND RESTATED EXECUTIVE RETENTION AGREEMENT