UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2IA9A8HCGw1FKvjZ52qgEwu/NPjZGQ1CUchT3TjS+dQ='
WHERE
key_id = '0f71eba826ac69e9aaf6f64a38621205d8558e59635467091479d2f2cd8d81e7'
AND (
token = '2IA9A8HCGw1FKvjZ52qgEwu/NPjZGQ1CUchT3TjS+dQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)