This refers to the cowbell played in the song Pigs (Three Different Ones)by Pink Floyd, off the album 'Animals' The cowbell is played by Nick Mason on this song, and it is absolutely awesome
Person 1: Yay, Pigs (Three Different Ones) just came on!
Person 2: omfg cowbell sex!