UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4JqHnsWCSBnOU+oqKaywgGIt9LUWy5vuQB5UzgCvdmM='
WHERE
key_id = '04fb0c7252f22bdc5a8de597efe4a3f3b547e1a543d53f2382ee86cc80a8d81b'
AND (
token = '4JqHnsWCSBnOU+oqKaywgGIt9LUWy5vuQB5UzgCvdmM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)