Use migration level lock-retries for cascading settings

What does this MR do and why?

Adapt the helper for cascaded settings to leverage !69658 (merged).

The intent is to remove subtransactions.

How to set up and validate locally

1. Create an example migration following the docs
2. Execute the migration locally

MR acceptance checklist

These checklists encourage us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

Documentation

• Confirmed

1. I have included changelog trailers, or I have decided that they are not needed. (Does this MR need a changelog?)
2. I have added/updated documentation, or I have decided that documentation changes are not needed for this MR. (Is documentation required?)