UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eFdqc4AtB65UcJ6bxVYhZBLY9pFrFksxZ6guyJpZBq0='
WHERE
key_id = 'e31d15a49bb8f0e01955bdd973cacfc74a545040627c9993cf9540aeb6e3594e'
AND (
token = 'eFdqc4AtB65UcJ6bxVYhZBLY9pFrFksxZ6guyJpZBq0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)