UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iWn96FLqzpE+JqjMdNJLJ198hyUj8N1xSSIwqAgMkmw='
WHERE
key_id = '384dffacb5a767fba5ad88225e0c14412a94b85c6724b1dff38299353996fe9d'
AND (
token = 'iWn96FLqzpE+JqjMdNJLJ198hyUj8N1xSSIwqAgMkmw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)