UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '50pvyjHys3SW6wc+akCSy6a/yFo18ARxLAWZ5wFRAeI='
WHERE
key_id = '7860a8354acbedfdeb3fc5c65de42b61507a997c2db344a79a8258b9a75681ce'
AND (
token = '50pvyjHys3SW6wc+akCSy6a/yFo18ARxLAWZ5wFRAeI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)