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