The 'Saturday Night Live' alum initially said in August 2023 that the prescription medication was helping him lose weight