UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PYGECpmM2EqDKHYzKftWrPs2/yUXE+FzWEuAUYsxVDk='
WHERE
key_id = 'b91c4d27a09cc975a5dd6ece271eff02c5a7fb1dbe72320f90e92df9ee29c91e'
AND (
token = 'PYGECpmM2EqDKHYzKftWrPs2/yUXE+FzWEuAUYsxVDk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)