SECOND CONSOLIDATED, AMENDED AND RESTATED SECURITY AGREEMENT