PLUS: Former 'SNL' cast member Chris Kattan talks about the moment that made everyone break character in the iconic 'More Cowbell' sketch