I created a new account and expired password and tried your solution. it worked. Should work on any account right? The password values for my account in question that needs to be "un-expired" is 43BA7BBC412AE7CB. If I change the password like you had shown, it should show account_status as open, right?

alter user test identified by values '43BA7BBC412AE7CB';