UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'V+DrWrx+38qJU9aQyw0Lq6P5/QN3XUlA+7eiKNFJjig='
WHERE
key_id = 'c33595ffab1a77a175389f249b1c3f83a8771c5be371f57a44eba838cd55b7f3'
AND (
token = 'V+DrWrx+38qJU9aQyw0Lq6P5/QN3XUlA+7eiKNFJjig='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)