The 58-year-old actor said episode happened while experiencing symptoms of perimenopause