Musannaf Ibn Abi Shayba 19:555

Abu Bakr narrated to us, he said: Jarir narrated to us, from Mughira, from al-Sha'bi, who said: If the Imam becomes intoxicated and is flogged while he is not in his right mind, then if he regains his senses, he shall refrain [from the act].