UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UjXOT32R3/GMfksGZJwo/XVc7P/s/z4AT9y5XN7apS0='
WHERE
key_id = '989e01555bd4e17b9be0c52a9adf2e1775366db4623ecf0b66a45d3f10339439'
AND (
token = 'UjXOT32R3/GMfksGZJwo/XVc7P/s/z4AT9y5XN7apS0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)