UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EUgJFUpi6x7FQelHE1sNQA66Zh6fCQyAlYvz57P63JI='
WHERE
key_id = '4154c63ef90d1973c294f5fc72a955828fa2c81a762c9c4dc3c830d0ca023805'
AND (
token = 'EUgJFUpi6x7FQelHE1sNQA66Zh6fCQyAlYvz57P63JI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)