UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'raMTY7qRf/+lYz0SUCEX7zzdYe+ZFUdQ0W2OiO+VjnU='
WHERE
key_id = 'c4764f90094ba7a3021c80468d2836c8535b2ed5c82c2b92b1596ae99749d0bc'
AND (
token = 'raMTY7qRf/+lYz0SUCEX7zzdYe+ZFUdQ0W2OiO+VjnU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)