UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xzIhfnpNaZ6cU+MV7ZtUW1n9WNDh61T7kcNR5j4lryo='
WHERE
key_id = 'f83dfb12ae739a742e59a2986d183fcc8a7ca5eb2cea35a9a212e2eaefcfb422'
AND (
token = 'xzIhfnpNaZ6cU+MV7ZtUW1n9WNDh61T7kcNR5j4lryo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)