UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BAC1/Ub052tf8RXkxwU9xqcVZV78yEsC5oNJRrhTO/U='
WHERE
key_id = '302e8d91da6f67303cbaf4974da4c0525598e5c3db5ac0000834a49eba9acf1b'
AND (
token = 'BAC1/Ub052tf8RXkxwU9xqcVZV78yEsC5oNJRrhTO/U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)