Marion Bowman Jr’s final appeal to stop the execution was rejected by the Supreme Court on Thursday