UPDATE
q_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qXEKe8lCJ33mFaA31VpErYB2blqDNdC9MQgzrQLpVsw='
WHERE
key_id = '7f489596f0f3dbf70f0152723d75c1ac5d20fa01df6b4bf0320b2efc970918f7'
AND (
token = 'qXEKe8lCJ33mFaA31VpErYB2blqDNdC9MQgzrQLpVsw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)