UPDATE
q_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ynPg3ztjBBpOdt0vehG2UbzdfbbnzGKXhAuX9SWRkT8='
WHERE
key_id = '9a79aa96a810c61339428c34991b59e56da48ddd7a60f9b3f4431ba8c0aecf1a'
AND (
token = 'ynPg3ztjBBpOdt0vehG2UbzdfbbnzGKXhAuX9SWRkT8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)