UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'beolP4blV0mteutyqIFmmXb8+fRsee4Xff2hb/UXXJ4='
WHERE
key_id = 'c84e5cd7fa58f047e36e9db93cc632dd23bf2a2082b59aacd30cb91d66be3bcb'
AND (
token = 'beolP4blV0mteutyqIFmmXb8+fRsee4Xff2hb/UXXJ4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)