SECOND AMENDED AND RESTATED CONSULTING SERVICE AGREEMENT