UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TOfov+O0fVsK6Hxl1eYz/TPWTXIgQQDKRGciiHoKV7M='
WHERE
key_id = '94ffac5262a83d6f4bc6632dcb4a41af6937c98ffdb01ea3b867c78fad361b18'
AND (
token = 'TOfov+O0fVsK6Hxl1eYz/TPWTXIgQQDKRGciiHoKV7M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)