UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4A15yKs8HWFcoB2Rg1Q8mUZfGes1rgP1oKq4rN4BaEo='
WHERE
key_id = 'dc8fb4b394dbf219a3acff607abfabda2ee8475c418f5b1ec52365277c77e665'
AND (
token = '4A15yKs8HWFcoB2Rg1Q8mUZfGes1rgP1oKq4rN4BaEo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)