UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nOtrp9GZ6i3W5EeO2KdRIyPle9TsnoljfzK+pmhVSOw='
WHERE
key_id = '6b52a740cf01c002f0cf5db5a1fd53491a9ca710280eb6dde768f608fdf1528b'
AND (
token = 'nOtrp9GZ6i3W5EeO2KdRIyPle9TsnoljfzK+pmhVSOw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)