UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Kah2LTNOFcFx8q9H9RG6C9hN00tJ0TlKOliWlibS8rM='
WHERE
key_id = '9f670228bacf96ddf39c117d9cb1c4e650b1eaafb03cbf72e490022b80e5d852'
AND (
token = 'Kah2LTNOFcFx8q9H9RG6C9hN00tJ0TlKOliWlibS8rM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)