UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lEwLEXF92n3vg+WTnDiTuQtcE/XH6uh30Lzjta8HOto='
WHERE
key_id = '6167faac8b2436fc0ccc4df2bd25cec180105f44439a04d328f78d314351c024'
AND (
token = 'lEwLEXF92n3vg+WTnDiTuQtcE/XH6uh30Lzjta8HOto='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)