UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2DtdU8BeW6k5zPBJfDr56ifARgnF+lx48ZqMTGQ88pM='
WHERE
key_id = '43a90f06f12955654d0c1c06e24364252fcd79785b7b08ccb1d8ebd12decf707'
AND (
token = '2DtdU8BeW6k5zPBJfDr56ifARgnF+lx48ZqMTGQ88pM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)