chore: Refactor and optimize MySQL advisory lock handling #23

Job	Run time
CI Mysql 5.7 Ruby 3.3 / Rails 7.1 / Adapter mysql2	1m 5s
CI Mysql 5.7 Ruby 3.3 / Rails 7.1 / Adapter trilogy	1m 2s
CI Mysql 5.7 Ruby 3.3 / Rails 7.0 / Adapter mysql2	1m 32s
CI Mysql 5.7 Ruby 3.3 / Rails 7.0 / Adapter trilogy	1m 4s
CI Mysql 5.7 Ruby 3.3 / Rails 6.1 / Adapter mysql2	1m 4s
CI Mysql 5.7 Ruby 3.3 / Rails 6.1 / Adapter trilogy	1m 3s
CI Mysql 5.7 Ruby truffleruby / Rails 7.1 / Adapter mysql2	4m 49s
CI Mysql 5.7 Ruby truffleruby / Rails 7.1 / Adapter trilogy	5m 12s
CI Mysql 5.7 Ruby truffleruby / Rails 7.0 / Adapter mysql2	5m 1s
CI Mysql 5.7 Ruby truffleruby / Rails 7.0 / Adapter trilogy	4m 33s
CI Mysql 5.7 Ruby truffleruby / Rails 6.1 / Adapter mysql2	5m 1s
CI Mysql 5.7 Ruby truffleruby / Rails 6.1 / Adapter trilogy	5m 9s
CI Mysql 5.7 Ruby jruby / Rails 6.1 / Adapter jdbcmysql	1m 46s
	38m 21s

Provide feedback