UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SvfkXK3a3jZ8v5MtAwJKXg2jBM33gsq4kDYVD0aKIeU='
WHERE
key_id = '3a13b39af889f5abb746e82a4b1a2bbc65f8ab2e137a7ca84ac9c8c06eccbf11'
AND (
token = 'SvfkXK3a3jZ8v5MtAwJKXg2jBM33gsq4kDYVD0aKIeU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)