Hackman had a health scare in 1990 and was then given a warning that saw him leave the industry for good