Opioids As Modulators of Cell Death and Survival—Unraveling Mechanisms and Revealing New Indications