chore: Refactor and optimize MySQL advisory lock handling #24

Job	Run time
CI Mysql 5.7 Ruby 3.3 / Rails 7.1 / Adapter mysql2	1m 3s
CI Mysql 5.7 Ruby 3.3 / Rails 7.1 / Adapter trilogy	1m 36s
CI Mysql 5.7 Ruby 3.3 / Rails 7.0 / Adapter mysql2	1m 4s
CI Mysql 5.7 Ruby 3.3 / Rails 7.0 / Adapter trilogy	1m 7s
CI Mysql 5.7 Ruby 3.3 / Rails 6.1 / Adapter mysql2	1m 29s
CI Mysql 5.7 Ruby 3.3 / Rails 6.1 / Adapter trilogy	1m 4s
CI Mysql 5.7 Ruby truffleruby / Rails 7.1 / Adapter mysql2	1m 18s
CI Mysql 5.7 Ruby truffleruby / Rails 7.1 / Adapter trilogy	1m 43s
CI Mysql 5.7 Ruby truffleruby / Rails 7.0 / Adapter mysql2	1m 35s
CI Mysql 5.7 Ruby truffleruby / Rails 7.0 / Adapter trilogy	1m 17s
CI Mysql 5.7 Ruby truffleruby / Rails 6.1 / Adapter mysql2	1m 17s
CI Mysql 5.7 Ruby truffleruby / Rails 6.1 / Adapter trilogy	1m 42s
CI Mysql 5.7 Ruby jruby / Rails 6.1 / Adapter jdbcmysql	2m 13s
	18m 28s

Provide feedback