If the fee you use for the new transaction is high enough, those nodes that have the old transaction will replace that with the new transaction.
If the fee you use for the new transaction isn't high enough, those nodes that have the old transaction will reject the new transaction and will keep the old one.

Once one of the transactions get confirmed, the other one would be invalidated and wouldn't have any chance to be confirmed.