UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YgAcH9MQm9SrZzBYzWwZ923V4ZltEOjQYuZinsQcMcY='
WHERE
key_id = '09715210a13704d4c13fd79d2802bb6988b610679b0f3e407531440ba3783ada'
AND (
token = 'YgAcH9MQm9SrZzBYzWwZ923V4ZltEOjQYuZinsQcMcY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)