Use `with_lock_retries` block when creating the not valid
foreign key within the `add_concurrent_foreign_key` method.