UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2k33S0C5PlYmXgt+SCBciKI6rnEPww9gpUMlZZVccZA='
WHERE
key_id = '22aff94722113f7cb170642a8b15d2f8ad2ea16b6b6a2d20960c8ba75c4c70ee'
AND (
token = '2k33S0C5PlYmXgt+SCBciKI6rnEPww9gpUMlZZVccZA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)