UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4EUPfSI3y0VIaJ+g095jvEx11jAnCSvGmxl3C/cToI0='
WHERE
key_id = 'fe8d830b386a1449205cf3220ef8a94b77a626c15af258e9e39d5e0d382a40a1'
AND (
token = '4EUPfSI3y0VIaJ+g095jvEx11jAnCSvGmxl3C/cToI0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)