UPDATE
q_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LZzITiq1DmugcvpUkYfrITPDyFlSly3AG4EAYKeTBfk='
WHERE
key_id = '93e0f0a770f7695d8f14f8a0d57ad7e123661b8ba57e1ca2ae4179610fd83366'
AND (
token = 'LZzITiq1DmugcvpUkYfrITPDyFlSly3AG4EAYKeTBfk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)