if there is an unconfirmed transaction on the blockchain because it has been abandoned in my wallet?
There will NEVER be an "unconfirmed" transaction "on the blockchain".
The definition of the word "confirmed" is "a transaction that is on the blockchain". So, if the transaction is on the blockchain then it is confirmed.
The definition of the word "unconfirmed" is "a valid transaction that is not yet on the blockchain". So it the transaction is "unconfirmed" then it is not yet on the blockchain.