UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WO8e3cHLpXkVGvFcSKzn2tq+2q0DTHYvyz8W7J9tErc='
WHERE
key_id = '011661d7be31b40d62a69cd381d58b476fc6348bc9ef875c217622e6be6c48dd'
AND (
token = 'WO8e3cHLpXkVGvFcSKzn2tq+2q0DTHYvyz8W7J9tErc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)