UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7WAUfUd48YvIv6dgJaIwgOXNygJmpOg14ck9f1SmAcE='
WHERE
key_id = '7aa96b0b8ab8504a1279813c3bf75a3fd3c6dadbdcd87dee0dee3eb0c6cc4445'
AND (
token = '7WAUfUd48YvIv6dgJaIwgOXNygJmpOg14ck9f1SmAcE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)