Slightly awkward.

I can only imagine the face of the cashier while ringing him up

My first job was at Safeway. I worked there for 2.5 years. This happened exactly one time that I witnessed. The only difference was that the guy also bought vaseline. Also, it was late at night, so you knew he planned it out so there would be the fewest possible witnesses.