I should really test this one day:

As a rule of thumb, if a transaction occupies the mempool long enough, around 48 hours, the transaction is dropped and the funds returned to the user's wallet.

-- $BTC