UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '75vuMoYKhyK/pl7iTOLrlPSD1Q2tk2ySdX6JrkpOZZY='
WHERE
key_id = '80398101a23d5e7751e84529da50b7dc0d2f5b47c3bc6f4acf3869ffb6979d25'
AND (
token = '75vuMoYKhyK/pl7iTOLrlPSD1Q2tk2ySdX6JrkpOZZY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)