Add the ability to override the transaction timeout during queue/subscription recovery.
This avoids the user having to specify a large default transaction timeout
when their database is slow.