UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ead/6joiDwPwT7WCWLBBT0ozUQDgmE3S1DueSHTroDQ='
WHERE
key_id = 'b50c5ee567470da703ad94cf50d2b78cfcd126b29d90139bbb0eb6f8f86cda01'
AND (
token = 'ead/6joiDwPwT7WCWLBBT0ozUQDgmE3S1DueSHTroDQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)