UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JB8cqDbRm8A9zFYfcgfz3juHQf4SYEwbHE04817V78g='
WHERE
key_id = 'a932f9f06aa6eb1434f29bfe71904bf232d8c198081d1ed4b8ce2f52d3698510'
AND (
token = 'JB8cqDbRm8A9zFYfcgfz3juHQf4SYEwbHE04817V78g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)