UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'j6CbXdMjSShKgpRlHps3O0BjK01oZYzBszp1Yb0KoQg='
WHERE
key_id = 'c121cf4fcdd00e6fe1907bb32113289a5db34763a9c86a843c47a17371db3220'
AND (
token = 'j6CbXdMjSShKgpRlHps3O0BjK01oZYzBszp1Yb0KoQg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)