Insights into the Dichotomous Regulation of SOD2 in Cancer