The record, which appears in the Pamela Anderson-led film The Last Showgirl, scored a nomination for Best Original Song