Stuck in "query end" status every 5 minutes
All uses of that table will run faster (some will run a lot faster) if you jettison id and make name the PRIMARY KEY.

Your UPDATE is currently looking in 2 BTrees, plus updating 2 BTrees.  The PK change would change those to 1 and 2.  More importantly it would simply the row locking.

How big is the table?  How much RAM do you have?  What is the value of innodb_buffer_pool_size?  innodb_io_read_threads?  What the heck, let's see SHOW VARIABLES LIKE 'innodb%';