For transactional migrations, apply with-lock-retries methodology at the
full transaction level. This allows us to remove usage of
with-lock-retries from helpers and we don't need to use it inside
migrations explicitly.

The overall intent here is to remove subtransactions.

See https://gitlab.com/gitlab-org/gitlab/-/issues/339115