UPDATE
q_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cVGl+/BKgk0XdVx/Ns0AMXztdYrdi9L40JmE3KIA6Qk='
WHERE
key_id = '546d9b390e5fc0afe13d1625c9adfc04fbcd8e4fa3f27d4feae610fdc4610920'
AND (
token = 'cVGl+/BKgk0XdVx/Ns0AMXztdYrdi9L40JmE3KIA6Qk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)