Carvey was an ‘SNL’ cast member for seven seasons, from 1986 to 1993