UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H3jO7LE2s2wPOpHthekWAqs3UD/YYAempLZL6dMiBpo='
WHERE
key_id = '64bccd06d5dcdbede8666c32b47ce4ca683c2767d073d393fe986b64aead9362'
AND (
token = 'H3jO7LE2s2wPOpHthekWAqs3UD/YYAempLZL6dMiBpo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)