This updates updates with_lock_retries V2, when called inside open
transaction, to check if lock retires are already enabled,
and if yes to execute the provided code block directly,
and raise the error if not.